You are not stupid. do not think of yourself that way. All of us long to be loved, this is really what you're talking about here isn't it? This doesn't make you stupid, it makes you like all of us everywhere on the planet.
Having said that, everyone deserves to be happy. At the risk of encroaching on territory not my business, it seems this relationship doesn't make you happy. It even seems possible that it causes pain.
only you know your true feelings, but if you're not happy you deserve to be - IMO you should seek out someone to be happy with.